package com.frost.mybatis.mapper;

import com.frost.mybatis.model.ArticleInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ArticleInfoMapper {
    @Select("select " +
            "tb.username,tb.age,tb.phone,tb.gender " +
            "from articleinfo ta LEFT JOIN userinfo tb on ta.uid=tb.id " +
            "where ta.id=#{id}")
    ArticleInfo queryArticleInfo(Integer id);
}
